<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%String path = request.getContextPath();
			String basePath = request.getScheme() + "://"
					+ request.getServerName() + ":" + request.getServerPort()
					+ path + "/";
%>
<%@ page import = "fms.services.*,fms.services.persistence.*"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<jsp:include page="top.jsp" />
	<head>
		<base href="<%=basePath%>">

		<meta http-equiv="pragma" content="no-cache">
		<meta http-equiv="cache-control" content="no-cache">
		<meta http-equiv="expires" content="0">
		<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
		<meta http-equiv="description" content="This is my page">

		<!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
	</head>


	<body>
	 <P align="center">
			 &nbsp;<FONT size="6"><STRONG>体育馆场地信息</STRONG></FONT>
		</P>
		<P align="center"></P><TABLE align="center" border="1" width="80%" bgcolor="#ffffff" bordercolor="#000000">
			<TR>
				<TD bordercolor="#c0c0c0" bgcolor="#c0c0c0">
					<P align="center">
						<FONT size="2"> <FONT size="2"> <FONT size="1">场地编号</FONT></FONT></FONT></P></TD>
				<TD bgcolor="#c0c0c0">
					<P align="center">
						<FONT size="2"><FONT size="2"> <FONT size="2"> <FONT size="1">场地类型</FONT></FONT></FONT></FONT></P></TD>
				<TD bgcolor="#c0c0c0">
					<P align="center">
						<FONT size="1"><FONT size="2"> <FONT size="2">场地容量</FONT></FONT></FONT></P></TD>
				<TD bgcolor="#c0c0c0">
					<P align="center">
						<FONT size="2"> <FONT size="2"> <FONT size="1">场地价格</FONT></FONT></FONT></P></TD>
				<TD bgcolor="#c0c0c0">
					<P align="center">
						<FONT size="1"><FONT size="1"><FONT size="2"> <FONT size="2"> 场地状态</FONT></FONT></FONT></FONT></P></TD>
				<TD bgcolor="#c0c0c0">
					<P align="center">
						<FONT size="1"> <FONT size="2"> <FONT size="2">场地操作</FONT></FONT></FONT>
					</P></TD>
		 </TR>

<%

    Connection conn = null;
    conn = ConnectionFactory.getFactory().getConnection();
    Statement stmt = conn.createStatement();
   	String sql = "select * from fieldinfo";
    ResultSet rs = stmt.executeQuery(sql);
%>			
	<%while(rs.next())
	{%>		
			
			<TR>
				<TD>
					<P align="center">
						<FONT size="2"> <%=rs.getObject("field_id")%></FONT> </P></TD>
				<TD>
					<P align="center">
						<FONT size="2"><%=rs.getObject("field_type")%></FONT> </P></TD>
				<TD>
					<P align="center">
						<FONT size="2"><%=rs.getObject("field_capacity")%></FONT> </P></TD>
				<TD>
					<P align="center">
						<FONT size="2"><%=rs.getObject("field_price")%></FONT> </P></TD>
				<TD>
					<P align="center">
						<FONT size="2"><%=rs.getObject("field_status")%></FONT> </P></TD>
				<TD>
					<P align="center">
						<FONT size="1"> <FONT size="2"><A href='deletefieldinfo.do?field_id=<%=rs.getObject("field_id")%>'>删除</A> <A href="updatefieldinfo.jsp?field_id=<%=rs.getObject("field_id")%>" title="修改 场地信息">修改</A></FONT></FONT>
					</P></TD></TR>
	<%}%></TABLE><P align="center"><FONT size="2"><A href="addfieldinfo.jsp" title="添加场地信息">添加场地信息</A> &nbsp;</FONT> <A href="index.jsp" title="返回首页"><FONT size="2">返回首页</FONT></A> </P></body>
</html>
<%
rs.close();
stmt.close();
conn.close();
%>
